Creating and editing an export configuration

The Meridian Asset Management SAP Connector can work with multiple export configurations that are each stored in separate files.

Each export configuration comprises:

• SAP Plant Maintenance server connection parameters
• Item filter parameters
• Output destination parameters

You can create and load export configuration files from within the SAP Connector user interface.

To create a new export configuration:

1. Start C:\Program Files\BC-Meridian\Program\SAP AMM Connector\BlueCieloECM.SAPInfoConnector.exe. The BlueCielo SAP Connector window opens.
2. On the File menu, click New config. The Settings dialog box appears.
3. Click options or type values using the descriptions in the following table.

To edit an existing export configuration:

1. Start C:\Program Files\BC-Meridian\Program\SAP AMM Connector\BlueCieloECM.SAPInfoConnector.exe. The BlueCielo SAP Connector window opens.
2. On the File menu, click Open. The Open Import Settings File dialog box appears.
3. Select the export configuration file (*.sapexp) that you want to edit and then click Open. The configuration file is loaded.
4. On the Tools menu, click Settings. The Settings dialog box appears.
5. Click options or type values using the descriptions in the following table.
6. Click OK to save the configuration file.

Export configuration options

Option	Description
Filtering group
Export Functional Locations	Always set to True to include functional location items in the export.
Export Equipment	Always set to True to include equipment items in the export.
Date modified after	The date after which the modified items will be included in the export. Leave empty to include items with any dates. This option has no effect if Incremental update is set to True.
Functional location starts with	The beginning characters of the identifiers of the functional locations to include in the export.
Extra conditions	Additional filter conditions separated by AND or OR. Each condition must contain a column name in SAP Plant Maintenance, an operator abbreviation, and the value to match surrounded by single quotation marks ('). The supported operator abbreviations are listed in the following table. Use the tilde (~) character to break up expressions longer than 70 characters. Filter condition operator abbreviations Operator Abbreviation equals EQ less than LT less equal LE like LIKE greater than GT greater than or equals GE not equals NE Example of a short expression: IWERK EQ '1000' OR IWERK NE '' Example of a long expression:  WERK LIKE '12%' AND ERDAT LT '20120501' ~ AND AEDAT LT '20120501'
Import Parameters group
Incremental update	Set to True to include only matching items that have been modified since the date in LastSuccessfulImport. Set to False to export all matching items.
LastSuccessfulImport	The date and time of the last successful export. This can also be manually reset in the configuration file (for example, 0001-01-01T00:00:00 or 2015-09-03T14:45:21.498+02:00).
Source SAP System group
Application server	The URL or IP address of the SAP Plant Maintenance server from which to export items.
System number	The number of the SAP Plant Maintenance instance from which to export items.
System ID	The system ID of the SAP Plant Maintenance instance from which to export items.
Client	The code of the client context from which to export items.
Language	The language with which to connect to the SAP Plant Maintenance server.
User name	The SAP Plant Maintenance account name with which to connect to the SAP Plant Maintenance server.
Password	The password for the account specified in User name.
Confirm password	The password for the account specified in User name.
Pool size	The number of concurrent connections to use to the SAP Plant Maintenance database. The default is 1.
Target Database group
ExportDBFilename	The fully-qualified path and filename of the Microsoft Access database to which to save the exported items. The substitution variable %1 may be specified to pass the filename as a parameter in the command line.

To save the current export configuration as a different file:

1. On the File menu, click Save As. The Save Export Settings File dialog box appears.
2. Modify the file name and click Save.